In G2 you could enter SUMPRODUCT($C$2:$C$22,$D$2:$D$22,--($A$2:$A$29=F2)) and then copy the formulas down. Alternatively, you could enter ... ... <看更多>
Search
Search
In G2 you could enter SUMPRODUCT($C$2:$C$22,$D$2:$D$22,--($A$2:$A$29=F2)) and then copy the formulas down. Alternatively, you could enter ... ... <看更多>